package com.iscreen.dbupgrade.queries.constants;

public interface DBConstants
{
	public final static String NOT_NULL = "NOT NULL";
	public final static String DEFAULT = "DEFAULT";
	public final static String CONSTRAINT = "CONSTRAINT";
	public final static String CREATE_TABLE = "CREATE TABLE";
	public final static String SELECT = "SELECT";
	public final static String SELECT_ANY = SELECT + "1";
	public final static String SELECT_ALL = SELECT + "*";
	public final static String INSERT_INTO = "INSERT INTO";
	public final static String FROM = "FROM";
	public final static String WHERE = "WHERE";
	public final static String LIKE = "LIKE";
	public final static String COMMENT = "COMMENT";
	public final static String PRIMARY_KEY = "PRIMARY KEY";
	public final static String PARTITION = "PARTITION";
	public final static String PARTITIONS = "PARTITIONS";
	public final static String PARTITION_BY = "PARTITION BY";
	public final static String VALUES = "VALUES";
	public final static String LESS_THAN = "LESS THAN";

	public final static String BOOLEAN = "BOOLEAN";
	public final static String DECIMAL = "DECIMAL";
	public final static String BIGINT = "BIGINT";
	public final static String DATE = "DATE";
	public final static String TIMESTAMP = "TIMESTAMP";
	public final static String UNSIGNED = "UNSIGNED";
	public final static String VARCHAR = "VARCHAR";

	public final static String YEAR = "YEAR";

	public final static int DECIMAL_PRECISION = 10;
	public final static int DECIMAL_DIGITS = 10;

	public final static int STRING_DEF_LEN = 50;

	public final static String PREFIX_PRIMARY_KEY = "PK_";
	public final static String PREFIX_FOREIGN_KEY = "FK_";
	public final static String PREFIX_PRIMARY_INDEX = "IX_";
	public final static String PREFIX_PARTITION_NAME = "P_";
	public final static String LAST_PARTITION_NAME = PREFIX_PARTITION_NAME
			+ "LAST";
}
